Clinical Trials Tableau System API - Implementation Template

This guide provides information on supporting functions for translating Veeva
data into Tableau format.

cdmsConversionTools

A library that implements tools for CDMS that converts
from Veeva to Tableau format.

Functions

fun createDemographics ( demoDataSet)

param demoDataSet is an array of objects with the Veeva demographics data.
return An array of objects with the Tableau format.

Converts the Veeva formatted demographics data to the Tableau formatted table structure.

fun createVitalSigns ( vitalSignsDataSet)

param createVitalSigns is an array of objects with the Veeva vital signs data.
return An array of objects with the Tableau format.

Converts the Veeva formatted vital signs data to the Tableau formatted table structure.

fun createPhysicalExam ( peDataSet)

param peDataSet is an array of objects with the Veeva physical exam data.
return An array of objects with the Tableau format.

Converts the Veeva formatted physical exam data to the Tableau formatted table structure.

fun createSubjects ( subjectDataSet)

param subjectDataSet is an array of objects with the Veeva subjects data.
return An array of objects with the Tableau format.

Converts the Veeva formatted subjects data to the Tableau formatted table structure.

fun createAE ( aeDataSet)

param aeDataSet is an array of objects with the Veeva adverse events data.
return An array of objects with the Tableau format.

Converts the Veeva formatted adverse events data to the Tableau formatted table structure.

ctmsConversionTools

A library that implements tools for CTMS that converts
from Veeva to Tableau format.

Functions

fun createCtmsSubjects ( subjectData)

param subjectData is an array of objects with the Veeva subject data.
return An array of objects with the Tableau format.

Converts the Veeva formatted subjects data to the Tableau formatted table structure.

fun createCtmsStudies ( studyData)

param studyData is an array of objects with the Veeva study data.
return An array of objects with the Tableau format.

Converts the Veeva formatted studies data to the Tableau formatted table structure.

fun createCtmsSites ( siteData)

param siteData is an array of objects with the Veeva site data.
return An array of objects with the Tableau format.

Converts the Veeva formatted sites data to the Tableau formatted table structure.

fun createCtmsEnrollment ( enrollmentData)

param enrollmentData is an array of objects with the Veeva enrollment data.
return An array of objects with the Tableau format.

Converts the Veeva formatted enrollment data to the Tableau formatted table structure.

fun createCtmsStudyCountry ( studyCountryData)

param studyCountryData is an array of objects with the Veeva study country data.
return An array of objects with the Tableau format.

Converts the Veeva formatted study country data to the Tableau formatted table structure.

fun createCtmsStudyArm ( studyArmData)

param studyArmData is an array of objects with the Veeva study arm data.
return An array of objects with the Tableau format.

Converts the Veeva formatted study arm data to the Tableau formatted table structure.

fun createCtmsVisitDefinition ( visitDefinitionData)

param visitDefinitionData is an array of objects with the Veeva visit definition data.
return An array of objects with the Tableau format.

Converts the Veeva formatted visit definition data to the Tableau formatted table structure.

fun createCtmsVisit ( visitData)

param visitData is an array of objects with the Veeva visit data.
return An array of objects with the Tableau format.

Converts the Veeva formatted visit data to the Tableau formatted table structure.

hyperSchema

This module defines functions for handling
hyper schema creation and upload.

Functions

fun generateCsvFileName ( source, businessObject)

param source is a String with the source.
param businessObject is a String with the business object.
return A globally unique string to be used as a file name without an extension.

Generates a globally unique file name for the processing of a tableau table with the provided source and businessObject fields.

fun getHyperInfo ( source, businessObject)

param source is a String with the source.
param businessObject is a String with the business object.
return An object with fields needed to create the datasource message or an empty object if not matched.

Gets the hyper file info for the provided source and businessObject. This information is used to create the upload datasource message.

fun getHyperSchema ( source, businessObject)

param source is a String with the source.
param businessObject is a String with the business object.
return the hyper schema for the provided fields or an empty array if not matched.

Gets the hyper schema structure for the provided source and businessObject fields.

hyperSchemaCdms

This module defines CDMS schemas.

Functions

fun getCdmsSubjectsSchema ( )

return An array of objects with the hyper schema.

Generates the CDMS subjects hyper schema.

fun getCdmsSubjectDemographicsSchema ( )

return An array of objects with the hyper schema.

Generates the CDMS subject demographics hyper schema.

fun getCdmsSubjectVitalsSchema ( )

return An array of objects with the hyper schema.

Generates the CDMS subject vitals hyper schema.

fun getCdmsSubjectPhysicalsSchema ( )

return An array of objects with the hyper schema.

Generates the CDMS subject physicals hyper schema.

fun getCdmsAdverseEventsSchema ( )

return An array of objects with the hyper schema.

Generates the CDMS adverse events hyper schema.

hyperSchemaCtms

This module defines CTMS schemas.

Functions

fun getCtmsSubjectsSchema ( )

return An array of objects with the hyper schema.

Generates the CTMS subjects hyper schema.

fun getCtmsStudiesSchema ( )

return An array of objects with the hyper schema.

Generates the CTMS studies hyper schema.

fun getCtmsSitesSchema ( )

return An array of objects with the hyper schema.

Generates the CTMS sites hyper schema.

fun getCtmsEnrollmentSchema ( )

return An array of objects with the hyper schema.

Generates the CTMS enrollment hyper schema.

fun getCtmsStudyCountriesSchema ( )

return An array of objects with the hyper schema.

Generates the CTMS study countries hyper schema.

fun getCtmsStudyArmsSchema ( )

return An array of objects with the hyper schema.

Generates the CTMS study arms hyper schema.

fun getCtmsVisitDefinitionsSchema ( )

return An array of objects with the hyper schema.

Generates the CTMS visit definitions hyper schema.

fun getCtmsVisitsSchema ( )

return An array of objects with the hyper schema.

Generates the CTMS visits hyper schema.